SELECT CONCAT(e.FirstName, ' ', e.MiddleName, ' ', e.LastName) AS [Employee Name],
       CONCAT(m.FirstName, ' ', m.MiddleName, ' ', m.LastName) AS [Manager Name]
FROM Employees e LEFT OUTER JOIN Employees m
  ON e.ManagerID = m.EmployeeID;
 
SELECT CONCAT(e.FirstName, ' ', e.MiddleName, ' ', e.LastName) AS [Employee Name],
       CONCAT(m.FirstName, ' ', m.MiddleName, ' ', m.LastName) AS [Manager Name]
FROM Employees e RIGHT OUTER JOIN Employees m
  ON e.ManagerID = m.EmployeeID;